
print 'Personalplaner Userrights'
go

print 'Grant tabeles to prsadmins begin'
go
grant select, insert, delete, update on PrsVerwaltung to prsadmins with grant option
grant select, insert, delete, update on Dienstplan to prsadmins with grant option
grant select, insert, delete, update on Colorplan to prsadmins with grant option
grant select, insert, delete, update on Person to prsadmins with grant option
grant select, insert, delete, update on Arbeitspensum to prsadmins with grant option
go
grant select, insert, delete, update on Arbeitszeit to prsadmins with grant option
grant select, insert, delete, update on Anstellung to prsadmins with grant option
grant select, insert, delete, update on ArbeitsPlan to prsadmins with grant option
grant select, insert, delete, update on Abteilung to prsadmins with grant option
grant select, insert, delete, update on PersonalAbteilung to prsadmins with grant option
go
grant select, insert, delete, update on Dienst to prsadmins with grant option
grant select, insert, delete, update on DienstZeit to prsadmins with grant option
grant select, insert, delete, update on Ferien to prsadmins with grant option
grant select, insert, delete, update on Beschreibung to prsadmins with grant option
grant select, insert, delete, update on PersonAnstellung to prsadmins with grant option
go
grant select, insert, delete, update on PersonZeiten to prsadmins with grant option
grant select, insert, delete, update on Options to prsadmins with grant option
grant select, insert, delete, update on Termin to prsadmins with grant option
grant select, insert, delete, update on Terminplan to prsadmins with grant option
grant select, insert, delete, update on DienstSerie to prsadmins with grant option
go
grant select, insert, delete, update on PlanungsJahr to prsadmins with grant option
grant select, insert, delete, update on ArbeitsTage to prsadmins with grant option
grant select, insert, delete, update on Saldoanpassung to prsadmins with grant option
grant select, insert, delete, update on Schemas to prsadmins with grant option
grant select, insert, delete, update on PlanSchema to prsadmins with grant option
go
grant select, insert, delete, update on DienstSchema to prsadmins with grant option
grant select, insert, delete, update on ArbeitsPlanzprs to prsadmins with grant option
grant select, insert, delete, update on mandant to prsadmins with grant option
grant select, insert, delete, update on userrights to prsadmins with grant option
go
print 'Grant tabeles to prsadmins end'
go

print 'Grant tabeles to prsusers begin'
go
grant select, insert, delete, update on Dienstplan to prsusers
grant select, insert, delete, update on Colorplan to prsusers
grant select, insert, delete, update on PersonZeiten to prsusers
grant select, insert, delete, update on Arbeitszeit to prsusers
grant select, insert, delete, update on ArbeitsPlan to prsusers
go
grant select, insert, delete, update on Ferien to prsusers
grant select, insert, delete, update on Beschreibung to prsusers
grant select, insert, delete, update on Options to prsusers
grant select, insert, delete, update on Termin to prsusers
grant select, insert, delete, update on Terminplan to prsusers
go
grant select, insert, delete, update on DienstSerie to prsusers
grant select, insert, delete, update on PlanungsJahr to prsusers
grant select, insert, delete, update on ArbeitsTage to prsusers
grant select, insert, delete, update on Saldoanpassung to prsusers
grant select, insert, delete, update on Schemas to prsusers
go
grant select, insert, delete, update on PlanSchema to prsusers
grant select, insert, delete, update on mandant to prsusers
grant select, insert, delete, update on userrights to prsusers
grant select on PrsVerwaltung to prsusers
grant select on Person to prsusers
go
grant select on Arbeitspensum to prsusers
grant select on Anstellung to prsusers
grant select on Abteilung to prsusers
grant select on PersonalAbteilung to prsusers
grant select on Dienst to prsusers
go
grant select on DienstZeit to prsusers
grant select on PersonAnstellung to prsusers
grant select on DienstSchema to prsusers
grant select, insert, delete, update on ArbeitsPlanzprs to prsusers
go
print 'Grant tabeles to prsusers end'
go

